<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<title>DLC Search Engine: src/main/java/DataAccess/postgresql/PostgreSQLWordDAO.java Source File</title>

<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="doxygen.css" rel="stylesheet" type="text/css" />

<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
  $(document).ready(function() { searchBox.OnSelectItem(0); });
</script>

</head>
<body>
<div id="top"><!-- do not remove this div! -->


<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  
  
  <td style="padding-left: 0.5em;">
   <div id="projectname">DLC Search Engine
   
   </div>
   
  </td>
  
  
  
 </tr>
 </tbody>
</table>
</div>

<!-- Generated by Doxygen 1.7.6.1 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="namespaces.html"><span>Packages</span></a></li>
      <li><a href="annotated.html"><span>Classes</span></a></li>
      <li class="current"><a href="files.html"><span>Files</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="Search" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
          </span>
        </div>
      </li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="files.html"><span>File&#160;List</span></a></li>
    </ul>
  </div>
</div>
<div class="header">
  <div class="headertitle">
<div class="title">src/main/java/DataAccess/postgresql/PostgreSQLWordDAO.java</div>  </div>
</div><!--header-->
<div class="contents">
<a href="_postgre_s_q_l_word_d_a_o_8java.html">Go to the documentation of this file.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 <span class="keyword">package </span>dataaccess.postgresql;
<a name="l00002"></a>00002 
<a name="l00003"></a>00003 <span class="keyword">import</span> com.utn.searchengine.Word;
<a name="l00004"></a>00004 <span class="keyword">import</span> dataaccess.dao.WordDAO;
<a name="l00005"></a>00005 <span class="keyword">import</span> dataaccess.dbmanager.PostgreDBManager;
<a name="l00006"></a>00006 <span class="keyword">import</span> java.sql.Connection;
<a name="l00007"></a>00007 <span class="keyword">import</span> java.sql.PreparedStatement;
<a name="l00008"></a>00008 <span class="keyword">import</span> java.sql.ResultSet;
<a name="l00009"></a>00009 <span class="keyword">import</span> java.sql.SQLException;
<a name="l00010"></a>00010 <span class="keyword">import</span> java.util.HashMap;
<a name="l00011"></a>00011 <span class="keyword">import</span> java.util.Map;
<a name="l00012"></a>00012 
<a name="l00017"></a><a class="code" href="classdataaccess_1_1postgresql_1_1_postgre_s_q_l_word_d_a_o.html">00017</a> <span class="keyword">public</span> <span class="keyword">class </span><a class="code" href="classdataaccess_1_1postgresql_1_1_postgre_s_q_l_word_d_a_o.html">PostgreSQLWordDAO</a> <span class="keyword">implements</span> <a class="code" href="interfacedataaccess_1_1dao_1_1_word_d_a_o.html">WordDAO</a> {
<a name="l00018"></a>00018 
<a name="l00026"></a><a class="code" href="classdataaccess_1_1postgresql_1_1_postgre_s_q_l_word_d_a_o.html#af4dd5f009436282ecd62b19a19c2f133">00026</a>     <span class="keyword">public</span> <span class="keywordtype">boolean</span> <a class="code" href="classdataaccess_1_1postgresql_1_1_postgre_s_q_l_word_d_a_o.html#af4dd5f009436282ecd62b19a19c2f133">saveWord</a>(<a class="code" href="classcom_1_1utn_1_1searchengine_1_1_word.html">Word</a> word) {
<a name="l00027"></a>00027         PreparedStatement st;
<a name="l00028"></a>00028         Connection con;
<a name="l00029"></a>00029         <span class="keywordflow">try</span> {
<a name="l00030"></a>00030             con = <a class="code" href="classdataaccess_1_1dbmanager_1_1_postgre_d_b_manager.html">PostgreDBManager</a>.<a class="code" href="classdataaccess_1_1dbmanager_1_1_postgre_d_b_manager.html#a1f08589b938029b7e2c0fac3080f651e">getConnection</a>();
<a name="l00031"></a>00031             <span class="keyword">synchronized</span> (con) {
<a name="l00032"></a>00032                 String query = <span class="stringliteral">&quot;select fn_save_word(?,?,?);&quot;</span>;
<a name="l00033"></a>00033                 st = con.prepareStatement(query);
<a name="l00034"></a>00034                 st.setString(1, word.<a class="code" href="classcom_1_1utn_1_1searchengine_1_1_word.html#a0178ae154e1b998a526042de4fe525be">getName</a>());
<a name="l00035"></a>00035                 st.setInt(2, word.<a class="code" href="classcom_1_1utn_1_1searchengine_1_1_word.html#a26c2057e690a42fe2488b70ce6809ee8">getNr</a>());
<a name="l00036"></a>00036                 st.setInt(3, word.<a class="code" href="classcom_1_1utn_1_1searchengine_1_1_word.html#a53883c29360813b31317a02e33509ccf">getMaxTF</a>());
<a name="l00037"></a>00037                 st.executeQuery();
<a name="l00038"></a>00038                 st.close();
<a name="l00039"></a>00039                 <span class="keywordflow">return</span> <span class="keyword">true</span>;
<a name="l00040"></a>00040             }
<a name="l00041"></a>00041         } <span class="keywordflow">catch</span> (SQLException ex) {
<a name="l00042"></a>00042             <span class="keywordflow">return</span> <span class="keyword">false</span>;
<a name="l00043"></a>00043         }
<a name="l00044"></a>00044     }
<a name="l00045"></a>00045 
<a name="l00055"></a><a class="code" href="classdataaccess_1_1postgresql_1_1_postgre_s_q_l_word_d_a_o.html#aabb6679c38d52dafecc1eb9135539fa2">00055</a>     <span class="keyword">public</span> <a class="code" href="classcom_1_1utn_1_1searchengine_1_1_word.html">Word</a> <a class="code" href="classdataaccess_1_1postgresql_1_1_postgre_s_q_l_word_d_a_o.html#aabb6679c38d52dafecc1eb9135539fa2">getWord</a>(<a class="code" href="classcom_1_1utn_1_1searchengine_1_1_word.html">Word</a> palabra) {
<a name="l00056"></a>00056         <a class="code" href="classcom_1_1utn_1_1searchengine_1_1_word.html">Word</a> ret = null;
<a name="l00057"></a>00057         PreparedStatement st;
<a name="l00058"></a>00058         Connection con;
<a name="l00059"></a>00059         <span class="keywordflow">try</span> {
<a name="l00060"></a>00060             con = <a class="code" href="classdataaccess_1_1dbmanager_1_1_postgre_d_b_manager.html">PostgreDBManager</a>.<a class="code" href="classdataaccess_1_1dbmanager_1_1_postgre_d_b_manager.html#a1f08589b938029b7e2c0fac3080f651e">getConnection</a>();
<a name="l00061"></a>00061             <span class="keyword">synchronized</span> (con) {
<a name="l00062"></a>00062                 String query = <span class="stringliteral">&quot;select name_Word,nr,max_Tf from Word where name_Word = ?&quot;</span>;
<a name="l00063"></a>00063                 st = con.prepareStatement(query);
<a name="l00064"></a>00064                 st.setString(1, palabra.<a class="code" href="classcom_1_1utn_1_1searchengine_1_1_word.html#a0178ae154e1b998a526042de4fe525be">getName</a>());
<a name="l00065"></a>00065                 ResultSet results = st.executeQuery();
<a name="l00066"></a>00066                 <span class="keywordflow">if</span> (results.next()) {
<a name="l00067"></a>00067                     ret = <span class="keyword">new</span> <a class="code" href="classcom_1_1utn_1_1searchengine_1_1_word.html">Word</a>(results.getString(<span class="stringliteral">&quot;name_Word&quot;</span>), results.getInt(<span class="stringliteral">&quot;nr&quot;</span>), results.getInt(<span class="stringliteral">&quot;max_Tf&quot;</span>));
<a name="l00068"></a>00068                 }
<a name="l00069"></a>00069                 results.close();
<a name="l00070"></a>00070                 st.close();
<a name="l00071"></a>00071             }
<a name="l00072"></a>00072         } <span class="keywordflow">catch</span> (SQLException ex) {
<a name="l00073"></a>00073         }
<a name="l00074"></a>00074         <span class="keywordflow">return</span> ret;
<a name="l00075"></a>00075     }
<a name="l00076"></a>00076 
<a name="l00077"></a><a class="code" href="classdataaccess_1_1postgresql_1_1_postgre_s_q_l_word_d_a_o.html#aa0a1f2db97af76ffa1067ce0769af6cb">00077</a>     <span class="keyword">public</span> Map&lt;String, Word&gt; <a class="code" href="classdataaccess_1_1postgresql_1_1_postgre_s_q_l_word_d_a_o.html#aa0a1f2db97af76ffa1067ce0769af6cb">getVocabulary</a>() {
<a name="l00078"></a>00078         Map&lt;String, Word&gt; Vocabulary = <span class="keyword">new</span> HashMap&lt;String, Word&gt;();
<a name="l00079"></a>00079         PreparedStatement st;
<a name="l00080"></a>00080         Connection con;
<a name="l00081"></a>00081         <span class="keywordflow">try</span> {
<a name="l00082"></a>00082             con = <a class="code" href="classdataaccess_1_1dbmanager_1_1_postgre_d_b_manager.html">PostgreDBManager</a>.<a class="code" href="classdataaccess_1_1dbmanager_1_1_postgre_d_b_manager.html#a1f08589b938029b7e2c0fac3080f651e">getConnection</a>();
<a name="l00083"></a>00083             <span class="keyword">synchronized</span> (con) {
<a name="l00084"></a>00084                 String query = <span class="stringliteral">&quot;select name_Word,nr,max_Tf from Word&quot;</span>;
<a name="l00085"></a>00085                 st = con.prepareStatement(query);
<a name="l00086"></a>00086                 ResultSet results = st.executeQuery();
<a name="l00087"></a>00087                 <span class="keywordflow">while</span> (results.next()) {
<a name="l00088"></a>00088                     Vocabulary.put(results.getString(<span class="stringliteral">&quot;name_Word&quot;</span>), <span class="keyword">new</span> <a class="code" href="classcom_1_1utn_1_1searchengine_1_1_word.html">Word</a>(results.getString(<span class="stringliteral">&quot;name_Word&quot;</span>), results.getInt(<span class="stringliteral">&quot;nr&quot;</span>), results.getInt(<span class="stringliteral">&quot;max_Tf&quot;</span>)));
<a name="l00089"></a>00089                 }
<a name="l00090"></a>00090                 results.close();
<a name="l00091"></a>00091                 st.close();
<a name="l00092"></a>00092             }
<a name="l00093"></a>00093         } <span class="keywordflow">catch</span> (SQLException ex) {
<a name="l00094"></a>00094             System.out.println(<span class="stringliteral">&quot;SQL Exception:&quot;</span> + ex.getMessage());
<a name="l00095"></a>00095         }
<a name="l00096"></a>00096         <span class="keywordflow">return</span> Vocabulary;
<a name="l00097"></a>00097     }
<a name="l00098"></a>00098 
<a name="l00099"></a><a class="code" href="classdataaccess_1_1postgresql_1_1_postgre_s_q_l_word_d_a_o.html#ae77df0affee89a844b40aa250af0658f">00099</a>     <span class="keyword">public</span> <span class="keywordtype">boolean</span> <a class="code" href="classdataaccess_1_1postgresql_1_1_postgre_s_q_l_word_d_a_o.html#ae77df0affee89a844b40aa250af0658f">deleteWord</a>(<a class="code" href="classcom_1_1utn_1_1searchengine_1_1_word.html">Word</a> palabra) {
<a name="l00100"></a>00100         <span class="keywordtype">boolean</span> ret;
<a name="l00101"></a>00101         PreparedStatement st;
<a name="l00102"></a>00102         Connection con = <a class="code" href="classdataaccess_1_1dbmanager_1_1_postgre_d_b_manager.html">PostgreDBManager</a>.<a class="code" href="classdataaccess_1_1dbmanager_1_1_postgre_d_b_manager.html#a1f08589b938029b7e2c0fac3080f651e">getConnection</a>();
<a name="l00103"></a>00103         <span class="keyword">synchronized</span> (con) {
<a name="l00104"></a>00104             <span class="keywordflow">try</span> {
<a name="l00105"></a>00105                 String queryPalabra = <span class="stringliteral">&quot;select pr_deleteWord(?);&quot;</span>;
<a name="l00106"></a>00106                 st = con.prepareStatement(queryPalabra);
<a name="l00107"></a>00107                 st.setString(1, palabra.<a class="code" href="classcom_1_1utn_1_1searchengine_1_1_word.html#a0178ae154e1b998a526042de4fe525be">getName</a>());
<a name="l00108"></a>00108                 ResultSet rs = st.executeQuery();
<a name="l00109"></a>00109                 rs.next();
<a name="l00110"></a>00110                 System.out.println(<span class="stringliteral">&quot;&quot;</span> + rs.getBoolean(1));
<a name="l00111"></a>00111                 st.close();
<a name="l00112"></a>00112                 ret = <span class="keyword">true</span>;
<a name="l00113"></a>00113             } <span class="keywordflow">catch</span> (SQLException ex) {
<a name="l00114"></a>00114                 ret = <span class="keyword">false</span>;
<a name="l00115"></a>00115             }
<a name="l00116"></a>00116         }
<a name="l00117"></a>00117         <span class="keywordflow">return</span> ret;
<a name="l00118"></a>00118     }
<a name="l00119"></a>00119 
<a name="l00120"></a><a class="code" href="classdataaccess_1_1postgresql_1_1_postgre_s_q_l_word_d_a_o.html#a8b9e63343f88e1ed973dd158701e66d8">00120</a>     <span class="keyword">public</span> <span class="keywordtype">int</span> <a class="code" href="classdataaccess_1_1postgresql_1_1_postgre_s_q_l_word_d_a_o.html#a8b9e63343f88e1ed973dd158701e66d8">getNrWord</a>(<a class="code" href="classcom_1_1utn_1_1searchengine_1_1_word.html">Word</a> word) {
<a name="l00121"></a>00121         <span class="keywordtype">int</span> nr = 0;
<a name="l00122"></a>00122         PreparedStatement st;
<a name="l00123"></a>00123         Connection con;
<a name="l00124"></a>00124         <span class="keywordflow">try</span> {
<a name="l00125"></a>00125             con = <a class="code" href="classdataaccess_1_1dbmanager_1_1_postgre_d_b_manager.html">PostgreDBManager</a>.<a class="code" href="classdataaccess_1_1dbmanager_1_1_postgre_d_b_manager.html#a1f08589b938029b7e2c0fac3080f651e">getConnection</a>();
<a name="l00126"></a>00126             <span class="keyword">synchronized</span> (con) {
<a name="l00127"></a>00127                 String query = <span class="stringliteral">&quot;select nr from Word where name_Word = ?&quot;</span>;
<a name="l00128"></a>00128                 st = con.prepareStatement(query);
<a name="l00129"></a>00129                 st.setString(1, word.<a class="code" href="classcom_1_1utn_1_1searchengine_1_1_word.html#a0178ae154e1b998a526042de4fe525be">getName</a>());
<a name="l00130"></a>00130                 ResultSet results = st.executeQuery();
<a name="l00131"></a>00131                 <span class="keywordflow">while</span> (results.next()) {
<a name="l00132"></a>00132                     nr = results.getInt(<span class="stringliteral">&quot;nr&quot;</span>);
<a name="l00133"></a>00133                 }
<a name="l00134"></a>00134                 results.close();
<a name="l00135"></a>00135                 st.close();
<a name="l00136"></a>00136             }
<a name="l00137"></a>00137         } <span class="keywordflow">catch</span> (SQLException ex) {
<a name="l00138"></a>00138             nr = -1;
<a name="l00139"></a>00139         }
<a name="l00140"></a>00140         <span class="keywordflow">return</span> nr;
<a name="l00141"></a>00141 
<a name="l00142"></a>00142     }
<a name="l00143"></a>00143 }
</pre></div></div><!-- contents -->
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>Namespaces</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark">&#160;</span>Variables</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>



<hr class="footer"/><address class="footer"><small>
Generated on Thu Feb 16 2012 02:45:40 for DLC Search Engine by &#160;<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.7.6.1
</small></address>

</body>
</html>
